package com.zsc.wxapp.mapper;


import org.springframework.stereotype.Repository;

@Repository
public interface PriceTag1Mapper {
//
//    @Insert({
//            "<script>",
//            "INSERT INTO price_tag (pt_uuid, cust_uuid, pic_urlid, pt_type, product_uuid, pt_create_date, ",
//            "recognized_price, product_name, direct_retail_price, cigarette_total_info_uuid, cust_total_info_uuid) VALUES ",
//            "<foreach collection='priceTags' item='priceTag' separator=','>",
//            "(#{priceTag.pt_uuid}, #{priceTag.cust_uuid}, #{priceTag.pic_urlid}, #{priceTag.pt_type}, ",
//            "#{priceTag.product_uuid}, #{priceTag.pt_create_date}, #{priceTag.recognized_price}, ",
//            "#{priceTag.product_name}, #{priceTag.direct_retail_price}, #{priceTag.cigarette_total_info_uuid}, ",
//            "#{priceTag.cust_total_info_uuid})",
//            "</foreach>",
//            "</script>"
//    })
//    void insertPriceTags(List<PriceTag> priceTags);
//
//
//    @Select("SELECT recognized_price FROM price_tag WHERE product_name = #{productName}")
//    Double findUserRetailPriceByProductName(String productName);
//
//    @Select("SELECT product_uuid FROM cigarette_info WHERE brand = #{productName}")
//    String findProductUuidByProductName(String productName);
//
//    @Select("SELECT product_upload_date, actual_retail_price " +
//            "FROM cigarette_info " +
//            "WHERE product_uuid = #{productUuid} " +
//            "AND product_upload_date >= CURDATE() - INTERVAL 90 DAY")
//    List<PriceNameData> getPriceData(String productUuid);
//
//    @Select("SELECT direct_retail_price, direct_whole_price, is_province, product_type_code, " +
//            "price_type_code_text,  brand_uuid, tar_qty, " +
//            "nicotine_qty, spec FROM cigarette_info WHERE product_uuid = #{productUuid}")
//    List<ProductDetails> getProductDetails(String productUuid);

}

